'

Enter a nested INDEX and MATCH function in cell K7 that examines the range B6:H25 and returns the corresponding employee information based on the match values in cell J7 and cell K6. Note K6 contains a validation list that can be used to select various lookup categories. Use the Data Validation list in cell J7 to select Employee_ID 31461 and select Salary in cell K6 to test the function.

Enter a conditional statistical function in cell K14 that calculates the total number of PT employees. Use the range E6:E25 to complete the function.

Enter a conditional statistical function in cell K15 that calculates the total value of PT employee salaries. Use the range E6:E25 to complete the function.

Enter a conditional statistical function in cell K16 that calculates the average value of PT employee salaries. Use the range E6:E25 to complete the function.

Enter a conditional statistical function in cell K17 that calculates the highest PT employee salary. Use the range E6:E25 to complete the function.

Use Advanced Filtering to restrict the data to only display FT employees based on the criteria in the range K10:K11. Place the results in cell A29.

Enter a database function in cell K18 to determine the total number of FT employees. To complete the function use the range A5:H25 as the database argument, cell E5 for the field, and the range K10:K11 for the criteria.

Enter a database function in cell K19 to determine the total value of FT employee salaries. To complete the function use the range A5:H25 as the database argument, cell H5 for the field, and the range K10:K11 for the criteria.